<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-8-18. 7:13:12-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Inventory']/model[@name='model']</modelPath>
				<drillBehavior/>
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1">
								<style>
									<defaultStyles>
										<defaultStyle refStyle="pg"/>
									</defaultStyles>
								<CSS value="width:1500px"/></style>
								<pageBody>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pb"/>
										</defaultStyles>
									</style>
									<contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Service Level Management</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Expected vs Actual Service Level</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><v2_combinationChart maxHotspots="10000" refQuery="Service Level List" name="Combination Chart1">
																				<v2_combinationTypeTooltips/>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition><style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style></v2_legend>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels></v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Service Level Range"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="volOrder"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_bar borders="show" borderColor="white">
																							<v2_solidPalette>
																								<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#CF2128" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#118B42" transparency="30"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor transparency="30" color="#0077BF"/></v2_fillEffect></v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																							<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Service Level Policy"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																					</v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange>
																							
																						<v2_specifiedRange max="1"/></v2_axisRange><v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="###,###,### Vols"/></dataFormat></style>
																						</v2_axisLabels><v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<CSS value="width:1480px;height:200px"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_defaultChartMeasure refDataItem="volCount"/></v2_combinationChart>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white;width:5px"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Service Level Management by Volume</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white;width:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="width:5px;background-color:white"/></style></tableCell><tableCell><contents/><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="width:5px;background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white;width:5px"/></style></tableCell><tableCell><contents>
																		<list horizontalPagination="true" name="List4" refQuery="Service Level List" rowsPerPage="20000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:left;padding-bottom:5px;font-family:Arial;font-size:12px;color:#808080;background-color:white;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Array"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#808080;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Array"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:left;padding-bottom:5px;font-family:Arial;font-size:12px;color:#808080;background-color:white;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Aggregate"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#808080;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Aggregate"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:left;padding-bottom:5px;font-family:Arial;font-size:12px;color:#808080;background-color:white;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Volume"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#808080;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Volume"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:left;padding-bottom:5px;font-family:Arial;font-size:12px;color:#808080;background-color:white;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Allocated Cost"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#808080;border-bottom:1px solid #E1E1E2"/><dataFormat><currencyFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Allocated Cost"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:left;padding-bottom:5px;font-family:Arial;font-size:12px;color:#808080;background-color:white;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Service Level Policy"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#808080;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Service Level Policy"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:left;padding-bottom:5px;font-family:Arial;font-size:12px;color:#808080;background-color:white;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Recommended Service Level"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#808080;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Recommended Service Level"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:left;padding-bottom:5px;font-family:Arial;font-size:12px;color:#808080;background-color:white;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Service Level Range"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#808080;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Service Level Range"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:left;padding-bottom:5px;font-family:Arial;font-size:12px;color:#808080;background-color:white;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Allocated (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#808080;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Allocated (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:left;padding-bottom:5px;font-family:Arial;font-size:12px;color:#808080;background-color:white;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#808080;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Used (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:left;padding-bottom:5px;font-family:Arial;font-size:12px;color:#808080;background-color:white;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Available (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#808080;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Available (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:left;padding-bottom:5px;font-family:Arial;font-size:12px;color:#808080;background-color:white;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Average Latency"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#808080;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Average Latency"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:left;padding-bottom:5px;font-family:Arial;font-size:12px;color:#808080;background-color:white;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Peak Latency"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#808080;border-bottom:1px solid #E1E1E2"/><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Peak Latency"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:left;padding-bottom:5px;font-family:Arial;font-size:12px;color:#808080;background-color:white;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="95th Percentile IOPS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#808080;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="95th Percentile IOPS"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:left;padding-bottom:5px;font-family:Arial;font-size:12px;color:#808080;background-color:white;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="I/O Density (95th Percentile)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#808080;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="I/O Density (95th Percentile)"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents><style><CSS value="text-align:center;padding-top:5px;padding-bottom:5px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white;width:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:#F7F7F7;height:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2016-06-29T14:54:31.323Z"/></XMLAttributes><queries><query name="Service Level List">
			<source>
				
			<sqlQuery name="SQL1" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT 	dwh_performance.storage_dimension.name AS 'Array',
	dwh_performance.storage_pool_dimension.name AS 'Aggregate',
	dwh_performance.internal_volume_dimension.name AS 'Volume',
	dwh_performance.application_dimension.name AS 'Application',
	dwh_inventory.tier.name AS 'Storage Tier',
	ROUND(dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024, 2) * dwh_inventory.tier.cost AS 'Allocated Tier Cost',
	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024, 2)  * dwh_inventory.tier.cost AS 'Used Tier Cost',
	(ROUND(dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024, 2) - ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024, 2)) * dwh_inventory.tier.cost AS 'Available Tier Cost',
	IF(ROUND((CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax 
		ORDER BY dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax SEPARATOR ','),
		',', 95/100 * COUNT(*) + 1), ',', -1) AS DECIMAL))
		/(CASE 	WHEN 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2) &lt; .02
			THEN 	.02
			ELSE 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2)
			END ), 0) &lt;= 128, '&lt;=128',
	IF(ROUND((CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax 
		ORDER BY dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax SEPARATOR ','),
		',', 95/100 * COUNT(*) + 1), ',', -1) AS DECIMAL))
		/(CASE 	WHEN 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2) &lt; .02
			THEN 	.02
			ELSE 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2)
			END ), 0) &lt;= 256, '128-256',
	IF(ROUND((CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax 
		ORDER BY dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax SEPARATOR ','),
		',', 95/100 * COUNT(*) + 1), ',', -1) AS DECIMAL))
		/(CASE 	WHEN 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2) &lt; .02
			THEN 	.02
			ELSE 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2)
			END ), 0) &lt;= 1024, '256-1024',
	IF(ROUND((CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax 
		ORDER BY dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax SEPARATOR ','),
		',', 95/100 * COUNT(*) + 1), ',', -1) AS DECIMAL))
		/(CASE 	WHEN 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2) &lt; .02
			THEN 	.02
			ELSE 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2)
			END ), 0) &lt;= 2048, '1024-2048',
	IF(ROUND((CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax 
		ORDER BY dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax SEPARATOR ','),
		',', 95/100 * COUNT(*) + 1), ',', -1) AS DECIMAL))
		/(CASE 	WHEN 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2) &lt; .02
			THEN 	.02
			ELSE 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2)
			END ), 0) &lt;= 4096, '2048-4096',
	IF(ROUND((CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax 
		ORDER BY dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax SEPARATOR ','),
		',', 95/100 * COUNT(*) + 1), ',', -1) AS DECIMAL))
		/(CASE 	WHEN 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2) &lt; .02
			THEN 	.02
			ELSE 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2)
			END ), 0) &lt;= 8192, '4096-8192',
	'8192+')))))) AS 'Service Level',
	IF(ROUND((CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax 
		ORDER BY dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax SEPARATOR ','),
		',', 95/100 * COUNT(*) + 1), ',', -1) AS DECIMAL))
		/(CASE 	WHEN 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2) &lt; .02
			THEN 	.02
			ELSE 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2)
			END ), 0) &lt;= 128, '&lt;=128',
	IF(ROUND((CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax 
		ORDER BY dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax SEPARATOR ','),
		',', 95/100 * COUNT(*) + 1), ',', -1) AS DECIMAL))
		/(CASE 	WHEN 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2) &lt; .02
			THEN 	.02
			ELSE 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2)
			END ), 0) &lt;= 256, '128-256',
	IF(ROUND((CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax 
		ORDER BY dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax SEPARATOR ','),
		',', 95/100 * COUNT(*) + 1), ',', -1) AS DECIMAL))
		/(CASE 	WHEN 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2) &lt; .02
			THEN 	.02
			ELSE 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2)
			END ), 0) &lt;= 1024, '256-1024',
	IF(ROUND((CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax 
		ORDER BY dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax SEPARATOR ','),
		',', 95/100 * COUNT(*) + 1), ',', -1) AS DECIMAL))
		/(CASE 	WHEN 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2) &lt; .02
			THEN 	.02
			ELSE 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2)
			END ), 0) &lt;= 2048, '1024-2048',
	IF(ROUND((CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax 
		ORDER BY dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax SEPARATOR ','),
		',', 95/100 * COUNT(*) + 1), ',', -1) AS DECIMAL))
		/(CASE 	WHEN 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2) &lt; .02
			THEN 	.02
			ELSE 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2)
			END ), 0) &lt;= 4096, '2048-4096',
	IF(ROUND((CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax 
		ORDER BY dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax SEPARATOR ','),
		',', 95/100 * COUNT(*) + 1), ',', -1) AS DECIMAL))
		/(CASE 	WHEN 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2) &lt; .02
			THEN 	.02
			ELSE 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2)
			END ), 0) &lt;= 8192, '4096-8192',
	'8192+')))))) AS 'Service Level Range',
	IF(ROUND((CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax 
		ORDER BY dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax SEPARATOR ','),
		',', 95/100 * COUNT(*) + 1), ',', -1) AS DECIMAL))
		/(CASE 	WHEN 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2) &lt; .02
			THEN 	.02
			ELSE 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2)
			END ), 0) &lt;= 128, 0,
	IF(ROUND((CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax 
		ORDER BY dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax SEPARATOR ','),
		',', 95/100 * COUNT(*) + 1), ',', -1) AS DECIMAL))
		/(CASE 	WHEN 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2) &lt; .02
			THEN 	.02
			ELSE 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2)
			END ), 0) &lt;= 512, 1,
	IF(ROUND((CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax 
		ORDER BY dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax SEPARATOR ','),
		',', 95/100 * COUNT(*) + 1), ',', -1) AS DECIMAL))
		/(CASE 	WHEN 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2) &lt; .02
			THEN 	.02
			ELSE 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2)
			END ), 0) &lt;= 1024, 2,
	IF(ROUND((CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax 
		ORDER BY dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax SEPARATOR ','),
		',', 95/100 * COUNT(*) + 1), ',', -1) AS DECIMAL))
		/(CASE 	WHEN 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2) &lt; .02
			THEN 	.02
			ELSE 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2)
			END ), 0) &lt;= 2048, 3,
	IF(ROUND((CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax 
		ORDER BY dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax SEPARATOR ','),
		',', 95/100 * COUNT(*) + 1), ',', -1) AS DECIMAL))
		/(CASE 	WHEN 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2) &lt; .02
			THEN 	.02
			ELSE 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2)
			END ), 0) &lt;= 4096, 4,
	IF(ROUND((CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax 
		ORDER BY dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax SEPARATOR ','),
		',', 95/100 * COUNT(*) + 1), ',', -1) AS DECIMAL))
		/(CASE 	WHEN 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2) &lt; .02
			THEN 	.02
			ELSE 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2)
			END ), 0) &lt;= 8192, 5,
	6)))))) AS volOrder,
	ROUND(dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024/1024, 2) AS 'Allocated (TB)',
	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2) AS 'Used (TB)',
	ROUND(dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024/1024, 2) - ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2) AS 'Available (TB)',
	ROUND(AVG(dwh_performance.internal_volume_hourly_performance_fact.totalResponseTime), 2) AS 'Average Latency',
	MAX(dwh_performance.internal_volume_hourly_performance_fact.totalResponseTimeMax) AS 'Peak Latency',
	ROUND((CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(
	GROUP_CONCAT(dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax ORDER BY dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax SEPARATOR ','),
		',', 95/100 * COUNT(*) + 1), ',', -1) AS DECIMAL))) AS '95th Percentile IOPS',
	ROUND((CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax 
		ORDER BY dwh_performance.internal_volume_hourly_performance_fact.totalIopsMax SEPARATOR ','),
		',', 95/100 * COUNT(*) + 1), ',', -1) AS DECIMAL))
		/(CASE 	WHEN 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2) &lt; .02
			THEN 	.02
			ELSE 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2)
			END ), 0) AS 'I/O Density (95th Percentile)',
	ROUND((CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(dwh_performance.internal_volume_hourly_performance_fact.readIops 
		ORDER BY dwh_performance.internal_volume_hourly_performance_fact.readIops SEPARATOR ','),
		',', 95/100 * COUNT(*) + 1), ',', -1) AS DECIMAL))
		/(CASE 	WHEN 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2) &lt; .02
			THEN 	.02
			ELSE 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2)
			END ), 0) AS 'Read I/O Density (95th Percentile)',
	ROUND((CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(dwh_performance.internal_volume_hourly_performance_fact.writeIops 
		ORDER BY dwh_performance.internal_volume_hourly_performance_fact.writeIops SEPARATOR ','),
		',', 95/100 * COUNT(*) + 1), ',', -1) AS DECIMAL))
		/(CASE 	WHEN 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2) &lt; .02
			THEN 	.02
			ELSE 	ROUND(dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024/1024, 2)
			END ), 0) AS 'Write I/O Density (95th Percentile)'
FROM 	dwh_performance.internal_volume_hourly_performance_fact
JOIN 	dwh_performance.date_dimension
ON 	dwh_performance.internal_volume_hourly_performance_fact.dateTk = dwh_performance.date_dimension.tk
AND 	dwh_performance.date_dimension.fullDate &gt;= ( 	SELECT 	MAX(dwh_performance.date_dimension.fullDate)
							FROM 	dwh_performance.internal_volume_hourly_performance_fact
							JOIN 	dwh_performance.date_dimension
							ON 	dwh_performance.internal_volume_hourly_performance_fact.dateTk = dwh_performance.date_dimension.tk ) - INTERVAL 7 DAY
JOIN 	dwh_performance.business_entity_dimension
ON 	dwh_performance.internal_volume_hourly_performance_fact.businessEntityTk = dwh_performance.business_entity_dimension.tk
JOIN 	dwh_performance.application_dimension
ON 	dwh_performance.internal_volume_hourly_performance_fact.applicationTk = dwh_performance.application_dimension.tk
JOIN 	dwh_performance.storage_dimension
ON 	dwh_performance.internal_volume_hourly_performance_fact.storageTk = dwh_performance.storage_dimension.tk
JOIN 	dwh_performance.storage_pool_dimension
ON 	dwh_performance.internal_volume_hourly_performance_fact.storagePoolTk = dwh_performance.storage_pool_dimension.tk
JOIN 	dwh_performance.tier_dimension
ON 	dwh_performance.internal_volume_hourly_performance_fact.tierTk = dwh_performance.tier_dimension.tk
JOIN 	dwh_performance.internal_volume_dimension
ON 	dwh_performance.internal_volume_hourly_performance_fact.internalVolumeTk = dwh_performance.internal_volume_dimension.tk
AND 	dwh_performance.internal_volume_dimension.name NOT LIKE '%root%'
AND 	dwh_performance.internal_volume_dimension.name NOT LIKE '%vol0'
JOIN 	dwh_inventory.internal_volume
ON 	dwh_performance.internal_volume_dimension.id = dwh_inventory.internal_volume.id
JOIN 	dwh_inventory.object_to_annotation
ON 	dwh_inventory.internal_volume.id = dwh_inventory.object_to_annotation.objectId
JOIN 	dwh_inventory.annotation_value
ON 	dwh_inventory.object_to_annotation.annotationValueId = dwh_inventory.annotation_value.id
JOIN 	dwh_inventory.tier
ON 	dwh_inventory.annotation_value.id = dwh_inventory.tier.id
GROUP BY
	dwh_performance.storage_dimension.name,
	dwh_performance.storage_pool_dimension.name,
	dwh_performance.internal_volume_dimension.name</sqlText>
		<mdProjectedItems><mdProjectedItem name="Array"/><mdProjectedItem name="Aggregate"/><mdProjectedItem name="Volume"/><mdProjectedItem name="Application"/><mdProjectedItem name="Storage Tier"/><mdProjectedItem name="Allocated Tier Cost"/><mdProjectedItem name="Used Tier Cost"/><mdProjectedItem name="Available Tier Cost"/><mdProjectedItem name="Service Level"/><mdProjectedItem name="Service Level Range"/><mdProjectedItem name="volOrder"/><mdProjectedItem name="Allocated (TB)"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Available (TB)"/><mdProjectedItem name="Average Latency"/><mdProjectedItem name="Peak Latency"/><mdProjectedItem name="95th Percentile IOPS"/><mdProjectedItem name="I/O Density (95th Percentile)"/><mdProjectedItem name="Read I/O Density (95th Percentile)"/><mdProjectedItem name="Write I/O Density (95th Percentile)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Array"><expression>[SQL1].[Array]</expression></dataItem><dataItem name="Aggregate"><expression>[SQL1].[Aggregate]</expression></dataItem><dataItem name="Volume"><expression>[SQL1].[Volume]</expression></dataItem><dataItem name="volCount" aggregate="count"><expression>[SQL1].[Volume]</expression></dataItem><dataItem name="Service Level Policy"><expression>[SQL1].[Storage Tier]</expression></dataItem><dataItem name="Allocated Cost"><expression>[SQL1].[Allocated Tier Cost]</expression></dataItem><dataItem name="Recommended Service Level"><expression>CASE  [SQL1].[Service Level]
WHEN  '&lt;=128'
THEN  'Capacity'
WHEN  '128-256'
THEN  'Value'
WHEN  '256-1024'
THEN  'Performance'
WHEN  '1024-2048'
THEN  'High Read'
WHEN  '2048-4096'
THEN  'High Write'
WHEN  '4096-8192'
THEN  'Extreme'
ELSE  'Extreme+'
END</expression></dataItem><dataItem name="Service Level Range"><expression>[SQL1].[Service Level Range]</expression></dataItem><dataItem name="volOrder"><expression>[SQL1].[volOrder]</expression></dataItem><dataItem name="Allocated (TB)"><expression>[SQL1].[Allocated (TB)]</expression></dataItem><dataItem name="Used (TB)"><expression>[SQL1].[Used (TB)]</expression></dataItem><dataItem name="Available (TB)"><expression>[SQL1].[Available (TB)]</expression></dataItem><dataItem name="Average Latency"><expression>[SQL1].[Average Latency]</expression></dataItem><dataItem name="Peak Latency"><expression>[SQL1].[Peak Latency]</expression></dataItem><dataItem name="95th Percentile IOPS"><expression>[SQL1].[95th Percentile IOPS]</expression></dataItem><dataItem name="I/O Density (95th Percentile)"><expression>[SQL1].[I/O Density (95th Percentile)]</expression></dataItem></selection>
		</query></queries><classStyles><classStyle name="ls"><CSS value="border-collapse:collapse"/></classStyle><classStyle name="lt"><CSS value="border-top-style:none;border-right-style:none;border-left-style:none;background-color:white;color:black;text-align:left;font-weight:bold;background-image:none;border-bottom:1.5pt solid black"/></classStyle><classStyle name="lc"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="lm"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black;background-image:none"/></classStyle><classStyle name="lh"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="lf"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="ih"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black;background-image:none"/></classStyle><classStyle name="if"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black;background-image:none"/></classStyle><classStyle name="is"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black;background-image:none"/></classStyle><classStyle name="oh"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="of"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black;background-image:none"/></classStyle><classStyle name="os"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black;background-image:none"/></classStyle></classStyles><reportName>SLM - Expected v Actual</reportName></report>